﻿<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0062)http://www.blogjava.net/shanben/archive/2008/07/09/213731.html -->
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" ""><HTML><HEAD 
id="Head"><META content="IE=5.0000" http-equiv="X-UA-Compatible">
<TITLE>	Sybase配置参数 - 志当存高远,功到自然成! - BlogJava </TITLE>
<META http-equiv="Content-Type" content="text/html; charset=utf-8">
<META name="keywords" id="metaKeywords" content="Sybase配置参数"><LINK href="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/common.css" 
rel="stylesheet" type="text/css"><LINK id="MainCss" href="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/style.css" 
rel="stylesheet" type="text/css"><LINK title="RSS" id="RSSLink" href="http://www.blogjava.net/shanben/rss.aspx" 
rel="alternate" type="application/rss+xml">
<META name="GENERATOR" content="MSHTML 11.00.9600.17631"></HEAD> 
<BODY>
<FORM name="Form1" id="Form1" onsubmit="javascript:return WebForm_OnSubmit();" 
action="213731.html" method="post">
<DIV><INPUT name="__EVENTTARGET" id="__EVENTTARGET" type="hidden"> <INPUT name="__EVENTARGUMENT" id="__EVENTARGUMENT" type="hidden"> 
<INPUT name="__VIEWSTATE" id="&#10;__VIEWSTATE" type="hidden"> </DIV>
<SCRIPT type="text/javascript">
//<![CDATA[
var theForm = document.forms['Form1'];
if (!theForm) {
    theForm = document.Form1;
}
function __doPostBack(eventTarget, eventArgument) {
    if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
        theForm.__EVENTTARGET.value = eventTarget;
        theForm.__EVENTARGUMENT.value = eventArgument;
        theForm.submit();
    }
}
//]]>
</SCRIPT>
 
<SCRIPT src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/WebResource.js" type="text/javascript"></SCRIPT>
 
<SCRIPT language="JavaScript">
									function ctlent(evt,id)
											{
												if(evt.ctrlKey && evt.keyCode == 13)
												{	
													try
													{
														TempSave(id);
													}
													catch(ex)
													{
													}
													finally
													{
													    __doPostBack('AjaxHolder$PostComment$btnSubmit','')
													}
												}
		
												}</SCRIPT>
												 
<SCRIPT language="JavaScript">function SetReplyAuhor(author){document.getElementById('AjaxHolder_PostComment_tbComment').value+="@"+author+"\n";document.getElementById('AjaxHolder_PostComment_tbComment').focus();return false}</SCRIPT>
 
<SCRIPT src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/ScriptResource.js" type="text/javascript"></SCRIPT>
 
<SCRIPT src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/ScriptResource(1).js" type="text/javascript"></SCRIPT>
 
<SCRIPT src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/ScriptResource(2).js" type="text/javascript"></SCRIPT>
 
<SCRIPT type="text/javascript">
//<![CDATA[
function WebForm_OnSubmit() {
if (typeof(ValidatorOnSubmit) == "function" && ValidatorOnSubmit() == false) return false;
return true;
}
//]]>
</SCRIPT>
         
<DIV id="top">
<DIV>
<TABLE>
  <TBODY>
  <TR>
    <TD class="HeaderTitles">
      <H1 class="HeaderTitle"><A class="HeaderMainTitle" id="Header1_HeaderTitle" 
      href="http://www.blogjava.net/shanben/">志当存高远,功到自然成!</A></H1>
      <P id="tagline">少年强则中国强,少年进步则中国进步!</P></TD></TR></TBODY></TABLE></DIV>
<DIV class="HeaderBar">
<TABLE class="HeaderBar" id="HeaderBar">
  <TBODY>
  <TR>
    <TD class="HeaderBarTab" nowrap=""><IMG align="absmiddle" id="Header1_StartButton" 
      style="border-width: 0px;" src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/WinXP-Olive_Spacer.gif">
      		         <A id="Header1_MyLinks1_HomeLink" href="http://www.blogjava.net/">BlogJava</A><IMG 
      align="absmiddle" id="Header1_MyLinks1_Divider1" style="border-width: 0px;" 
      src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/WinXP-Olive_Divider.gif"> 
      <A id="Header1_MyLinks1_MyHomeLink" href="http://www.blogjava.net/shanben/">首页</A><IMG 
      align="absmiddle" id="Header1_MyLinks1_Image1" style="border-width: 0px;" 
      src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/WinXP-Olive_Divider.gif"> 
      <A id="Header1_MyLinks1_NewPostLink" href="http://www.blogjava.net/shanben/admin/EditPosts.aspx?opt=1">新随笔</A><IMG 
      align="absmiddle" id="Header1_MyLinks1_Image2" style="border-width: 0px;" 
      src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/WinXP-Olive_Divider.gif"> 
      <A id="Header1_MyLinks1_ContactLink" accesskey="9" href="http://www.blogjava.net/shanben/contact.aspx?id=1">联系</A><IMG 
      align="absmiddle" id="Header1_MyLinks1_Divider2" style="border-width: 0px;" 
      src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/WinXP-Olive_Divider.gif"> 
      <A id="Header1_MyLinks1_Syndication" href="http://www.blogjava.net/shanben/rss" 
      target="_blank">聚合</A><IMG align="absmiddle" id="Header1_MyLinks1_Divider3" 
      style="border-width: 0px;" src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/WinXP-Olive_Divider.gif"> <!--<a id="Header1_MyLinks1_Syndication2" href="../../../../../Atom.aspx" target="_blank">Syndicate this Site (Atom)</a><img id="Header1_MyLinks1_Divider6" src="../../../../../Skins/WinXPOlive/Images/WinXP-Olive_Divider.gif" align="absmiddle" style="border-width:0px;" />
<a id="Header1_MyLinks1_XMLLink" class="XMLLink" href="http://www.blogjava.net/shanben/rss" target="_blank"><img src="http://www.blogjava.net/images/xml.gif" style="border-width:0px;" /></a>--> 
      <A id="Header1_MyLinks1_Admin" href="http://www.blogjava.net/shanben/admin/EditPosts.aspx">管理</A><IMG 
      align="absmiddle" id="Header1_MyLinks1_Divider5" style="border-width: 0px;" 
      src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/WinXP-Olive_Divider.gif">
      			 </TD>
    <TD width="100%" class="HeaderBarTabBack" nowrap="">
      <DIV class="BlogStatsBar">
      <TABLE class="BlogStatsBar">
        <TBODY>
        <TR>
          <TD width="100%"></TD>
          <TD class="BlogStatsBar" nowrap="">				&nbsp;				53 
            				Posts&nbsp;::				2 Stories				::				1 Comments				::				0 
            Trackbacks
			 </TD></TR></TBODY></TABLE></DIV></TD></TR></TBODY></TABLE></DIV></DIV>
<DIV id="leftmenu" style="display: none;">
<H3>常用链接</H3>
<UL>
  <LI><A id="SingleColumn1_ctl00_repeaterLinks_ctl01_lnkLinkItem" href="http://www.blogjava.net/shanben/MyPosts.html">我的随笔</A></LI>
  <LI><A id="SingleColumn1_ctl00_repeaterLinks_ctl02_lnkLinkItem" href="http://www.blogjava.net/shanben/MyComments.html">我的评论</A></LI>
  <LI><A id="SingleColumn1_ctl00_repeaterLinks_ctl03_lnkLinkItem" href="http://www.blogjava.net/shanben/OtherPosts.html">我的参与</A></LI>
  <LI><A id="SingleColumn1_ctl00_repeaterLinks_ctl04_lnkLinkItem" href="http://www.blogjava.net/shanben/RecentComments.html">最新评论</A></LI></UL>
<H3>留言簿<SPAN style="font-size: 11px; font-weight: normal;">(4)</SPAN></H3>
<UL>
  <LI><A id="SingleColumn1_ctl01_lnkMessages" href="http://www.blogjava.net/shanben/Contact.aspx?id=1">给我留言</A>
	 
  <LI><A id="SingleColumn1_ctl01_lnkPublicMsgView" href="http://www.blogjava.net/shanben/default.aspx?opt=msg">查看公开留言</A>
	 
  <LI><A id="SingleColumn1_ctl01_lnkPrivateMsgView" href="http://www.blogjava.net/shanben/admin/MyMessages.aspx">查看私人留言</A>
  	 </LI></UL>
<H3>随笔分类</H3>
<UL>
  <LI><A title="Subscribe to JAVA插件开发(1)" id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl01_RssLink" 
  href="http://www.blogjava.net/shanben/category/37380.html/rss"><IMG align="center" 
  src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/xml.gif" 
  border="0"></A> <A id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl01_Link" 
  href="http://www.blogjava.net/shanben/category/37380.html">JAVA插件开发(1)</A></LI>
  <LI><A title="Subscribe to Oracle(7)" id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl02_RssLink" 
  href="http://www.blogjava.net/shanben/category/31808.html/rss"><IMG align="center" 
  src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/xml.gif" 
  border="0"></A> <A id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl02_Link" 
  href="http://www.blogjava.net/shanben/category/31808.html">Oracle(7)</A></LI>
  <LI><A title="Subscribe to Spring" id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl03_RssLink" 
  href="http://www.blogjava.net/shanben/category/31120.html/rss"><IMG align="center" 
  src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/xml.gif" 
  border="0"></A> <A id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl03_Link" 
  href="http://www.blogjava.net/shanben/category/31120.html">Spring</A></LI>
  <LI><A title="Subscribe to SQL_Server(1)" id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl04_RssLink" 
  href="http://www.blogjava.net/shanben/category/32845.html/rss"><IMG align="center" 
  src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/xml.gif" 
  border="0"></A> <A id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl04_Link" 
  href="http://www.blogjava.net/shanben/category/32845.html">SQL_Server(1)</A></LI>
  <LI><A title="Subscribe to Sybase(18)" id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl05_RssLink" 
  href="http://www.blogjava.net/shanben/category/32687.html/rss"><IMG align="center" 
  src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/xml.gif" 
  border="0"></A> <A id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl05_Link" 
  href="http://www.blogjava.net/shanben/category/32687.html">Sybase(18)</A></LI>
  <LI><A title="Subscribe to WebService开发(2)" id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl06_RssLink" 
  href="http://www.blogjava.net/shanben/category/35938.html/rss"><IMG align="center" 
  src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/xml.gif" 
  border="0"></A> <A id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl06_Link" 
  href="http://www.blogjava.net/shanben/category/35938.html">WebService开发(2)</A></LI>
  <LI><A title="Subscribe to 存储技术" id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl07_RssLink" 
  href="http://www.blogjava.net/shanben/category/47685.html/rss"><IMG align="center" 
  src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/xml.gif" 
  border="0"></A> <A id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl07_Link" 
  href="http://www.blogjava.net/shanben/category/47685.html">存储技术</A></LI>
  <LI><A title="Subscribe to 层次结构数据与关系数据库(3)" id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl08_RssLink" 
  href="http://www.blogjava.net/shanben/category/32599.html/rss"><IMG align="center" 
  src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/xml.gif" 
  border="0"></A> <A id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl08_Link" 
  href="http://www.blogjava.net/shanben/category/32599.html">层次结构数据与关系数据库(3)</A></LI>
  <LI><A title="Subscribe to 应用服务器调优与管理(4)" id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl09_RssLink" 
  href="http://www.blogjava.net/shanben/category/32658.html/rss"><IMG align="center" 
  src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/xml.gif" 
  border="0"></A> <A id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl09_Link" 
  href="http://www.blogjava.net/shanben/category/32658.html">应用服务器调优与管理(4)</A></LI>
  <LI><A title="Subscribe to 权限设计(1)" id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl10_RssLink" 
  href="http://www.blogjava.net/shanben/category/31807.html/rss"><IMG align="center" 
  src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/xml.gif" 
  border="0"></A> <A id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl10_Link" 
  href="http://www.blogjava.net/shanben/category/31807.html">权限设计(1)</A></LI>
  <LI><A title="Subscribe to 架构设计(5)" id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl11_RssLink" 
  href="http://www.blogjava.net/shanben/category/45926.html/rss"><IMG align="center" 
  src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/xml.gif" 
  border="0"></A> <A id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl11_Link" 
  href="http://www.blogjava.net/shanben/category/45926.html">架构设计(5)</A></LI>
  <LI><A title="Subscribe to 项目管理(3)" id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl12_RssLink" 
  href="http://www.blogjava.net/shanben/category/31925.html/rss"><IMG align="center" 
  src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/xml.gif" 
  border="0"></A> <A id="SingleColumn1_Categories_CatList_ctl00_LinkList_ctl12_Link" 
  href="http://www.blogjava.net/shanben/category/31925.html">项目管理(3)</A></LI></UL>
<H3>随笔档案</H3>
<UL>
  <LI><A id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl01_Link" href="http://www.blogjava.net/shanben/archive/2010/08.html">2010年8月 
  (6)</A></LI>
  <LI><A id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl02_Link" href="http://www.blogjava.net/shanben/archive/2009/02.html">2009年2月 
  (1)</A></LI>
  <LI><A id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl03_Link" href="http://www.blogjava.net/shanben/archive/2009/01.html">2009年1月 
  (1)</A></LI>
  <LI><A id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl04_Link" href="http://www.blogjava.net/shanben/archive/2008/11.html">2008年11月 
  (3)</A></LI>
  <LI><A id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl05_Link" href="http://www.blogjava.net/shanben/archive/2008/09.html">2008年9月 
  (6)</A></LI>
  <LI><A id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl06_Link" href="http://www.blogjava.net/shanben/archive/2008/08.html">2008年8月 
  (1)</A></LI>
  <LI><A id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl07_Link" href="http://www.blogjava.net/shanben/archive/2008/07.html">2008年7月 
  (18)</A></LI>
  <LI><A id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl08_Link" href="http://www.blogjava.net/shanben/archive/2008/06.html">2008年6月 
  (7)</A></LI>
  <LI><A id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl09_Link" href="http://www.blogjava.net/shanben/archive/2008/05.html">2008年5月 
  (5)</A></LI>
  <LI><A id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl10_Link" href="http://www.blogjava.net/shanben/archive/2008/04.html">2008年4月 
  (2)</A></LI>
  <LI><A id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl11_Link" href="http://www.blogjava.net/shanben/archive/2007/04.html">2007年4月 
  (1)</A></LI>
  <LI><A id="SingleColumn1_Categories_CatList_ctl01_LinkList_ctl12_Link" href="http://www.blogjava.net/shanben/archive/2006/11.html">2006年11月 
  (2)</A></LI></UL>
<H3>文章档案</H3>
<UL>
  <LI><A id="SingleColumn1_Categories_CatList_ctl02_LinkList_ctl01_Link" href="http://www.blogjava.net/shanben/archives/2006/11.html">2006年11月 
  (2)</A></LI></UL>
<H3>DB</H3>
<UL>
  <LI><A id="SingleColumn1_Categories_CatList_ctl03_LinkList_ctl01_Link" href="http://www.eygle.com/">eygle－－数据库知识网站</A></LI>
  <LI><A id="SingleColumn1_Categories_CatList_ctl03_LinkList_ctl02_Link" href="http://www.itpub.net/viewthread.php?tid=976460">一次weblogic调优的经过</A></LI></UL>
<H3>应用服务器管理与调优</H3>
<UL>
  <LI><A id="SingleColumn1_Categories_CatList_ctl04_LinkList_ctl01_Link" href="http://www.lwbst.com/NewsView.do?newsID=5787">BEA 
  Weblogic 调优</A></LI>
  <LI><A id="SingleColumn1_Categories_CatList_ctl04_LinkList_ctl02_Link" href="http://www.cntesting.com/portal/html/testing-technique/load-test/20070509/178.html">BEA 
  WebLogic平台下J2EE调优攻略：性能监控和性能分析 </A></LI></UL>
<H3>脚本技术</H3>
<UL>
  <LI><A id="SingleColumn1_Categories_CatList_ctl05_LinkList_ctl01_Link" href="http://shiningray.cn/improve-javascript-performance.html">如何优化JavaScript脚本的性能</A></LI></UL>
<SCRIPT language="JavaScript">
function SearchGoogle(key,evt,site)
		{
			if(evt.keyCode==13 || evt.keyCode==0 || evt.type =='click')
			{
				key.focus();
				var keystr = encodeURIComponent(key.value);
				url = "http://www.google.com/search?q=";
				url = url+keystr;
				url += "&ie=UTF-8&oe=GB2312&hl=zh-CN&domains="+site+"&sitesearch="+site;
				window.location=url;
				return false;
			}
		}
</SCRIPT>
 
<H3>搜索</H3>
<UL>
  <LI>
  <LI><INPUT name="q" id="q" style="width: 130px;" onkeydown="return SearchGoogle(document.getElementById('q'),event,'www.blogjava.net/shanben')" type="text">&nbsp;<INPUT name="sa" onclick="SearchGoogle(document.getElementById('q'),event,'www.blogjava.net/shanben')" type="button" value="搜索">
  	 </LI></UL>
<H3>最新评论	 <A id="SingleColumn1__1095770_RSSHyperlink1" href="http://www.blogjava.net/shanben/CommentsRSS.aspx"><IMG 
style="border-width: 0px;" src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/xml(1).gif"></A></H3>
<DIV class="RecentComment">
<UL>
  <LI style="-ms-word-break: break-all;"><A id="SingleColumn1__1095770_CommentList_ctl01_Hyperlink1" 
  href="http://www.blogjava.net/shanben/archive/2014/09/05/328581.html#417727">1.&nbsp;re: 
  java版的memcached client及使用文档</A>			 </LI>
  <LI style="-ms-word-break: break-all;">				你他妈的傻逼啊. 用什么类包啊 类包 你大爷的 草你妈
			 </LI>
  <LI style="text-align: right; margin-right: 4px;">--aaaaaaa</LI></UL></DIV>
<H3>阅读排行榜</H3>
<DIV class="RecentComment">
<UL style="-ms-word-break: break-all;">
  <LI><A id="SingleColumn1__1ab8eae_TopList_ctl01_Hyperlink1" href="http://www.blogjava.net/shanben/archive/2010/08/11/328581.html">1.&nbsp;java版的memcached 
  client及使用文档(9670)</A>			 </LI>
  <LI><A id="SingleColumn1__1ab8eae_TopList_ctl02_Hyperlink1" href="http://www.blogjava.net/shanben/archive/2008/07/09/213731.html">2.&nbsp;Sybase配置参数(6639)</A>
  			 </LI>
  <LI><A id="SingleColumn1__1ab8eae_TopList_ctl03_Hyperlink1" href="http://www.blogjava.net/shanben/archive/2008/07/08/213244.html">3.&nbsp;Sybase 
  常用sql语句(5453)</A>			 </LI>
  <LI><A id="SingleColumn1__1ab8eae_TopList_ctl04_Hyperlink1" href="http://www.blogjava.net/shanben/archive/2008/11/13/240195.html">4.&nbsp;Weblogic+Axis实现webservice(4901)</A>
  			 </LI>
  <LI><A id="SingleColumn1__1ab8eae_TopList_ctl05_Hyperlink1" href="http://www.blogjava.net/shanben/archive/2008/11/13/240194.html">5.&nbsp;Tomcat+Axis实现webservice(4308)</A>
  			 </LI></UL></DIV>
<H3>评论排行榜</H3>
<DIV class="RecentComment">
<UL style="-ms-word-break: break-all;">
  <LI><A id="SingleColumn1__30e4f22_TopList_ctl01_Hyperlink1" href="http://www.blogjava.net/shanben/archive/2010/08/11/328581.html">1.&nbsp;java版的memcached 
  client及使用文档(1)</A>			 </LI>
  <LI><A id="SingleColumn1__30e4f22_TopList_ctl02_Hyperlink1" href="http://www.blogjava.net/shanben/archive/2010/08/11/328534.html">2.&nbsp;高负载、高并发网站架构知识汇总-大流量网站架构的几点认识(0)</A>
  			 </LI>
  <LI><A id="SingleColumn1__30e4f22_TopList_ctl03_Hyperlink1" href="http://www.blogjava.net/shanben/archive/2010/08/11/328532.html">3.&nbsp;TOMCAT崩溃事件(0)</A>
  			 </LI>
  <LI><A id="SingleColumn1__30e4f22_TopList_ctl04_Hyperlink1" href="http://www.blogjava.net/shanben/archive/2010/08/11/328531.html">4.&nbsp;分布式缓存系统Memcached简介与实践(0)</A>
  			 </LI>
  <LI><A id="SingleColumn1__30e4f22_TopList_ctl05_Hyperlink1" href="http://www.blogjava.net/shanben/archive/2010/08/11/328527.html">5.&nbsp;Memcached学习笔记——windows上初步使用(0)</A>
  			 </LI></UL></DIV></DIV>
<DIV id="main">
<DIV class="post">
<DIV class="postTitle"><A id="viewpost1_TitleUrl" href="http://www.blogjava.net/shanben/archive/2008/07/09/213731.html">Sybase配置参数</A>
	 </DIV>
<DIV class="postText">
<DIV class="subtable altbg2 t_msg" 
style="width: auto; height: auto;"><STRONG>Sybase配置参数</STRONG><BR><BR>sp_configure 
'max online engines',4<BR>go<BR>--配置启动cpu个数<BR>sp_configure 'number of engines 
at startup',4 <BR>go<BR>--配置最大内存数<BR>sp_configure 'max memory' ,2097151<BR>
go<BR>--分配最大存储过程缓存<BR>sp_configure 'procedure cache',102400<BR>
go<BR>--配置高速缓存<BR>sp_cacheconfig&nbsp;&nbsp;'default data cache' , '700M'<BR>
go<BR>--缺省缓存分配页大小<BR>sp_poolconfig 'default data cache','200M','16K'<BR>
go<BR>--网络包大小<BR>sp_configure 'max network packet size',1024<BR>
go<BR><BR>--最大连接数<BR>sp_configure 'number of user connections',500<BR>
go<BR>--最大打开对象<BR>sp_configure&nbsp;&nbsp;'number of open object',9000<BR>
go<BR>--最大索引<BR>sp_configure&nbsp;&nbsp;'number of open index',10000<BR>
go<BR>--最大锁数<BR>sp_configure&nbsp;&nbsp;'number of locks',100000<BR>
go<BR><BR>--增加网络内存<BR>--sp_configure&nbsp;&nbsp;'additional network 
memory',1024<BR>go<BR><BR>--锁内存<BR>sp_configure&nbsp;&nbsp;'lock shared 
memory',512<BR>go<BR><BR>--优化tempdb<BR>select dbid, name,segmap<BR>from 
sysusages,&nbsp;&nbsp;sysdevices<BR>where sysdevices.low&nbsp;&nbsp;&lt;= 
sysusages.size +vstart<BR>and sysdevices.high &gt;=sysusages.size+vstart -1<BR>
and dbid =2<BR>and (status=2 or status=3) <BR>go<BR>use tempdb<BR>go<BR>
sp_dropsegment&nbsp;&nbsp;'default',tempdb,master<BR>go<BR>
sp_dropsegment&nbsp;&nbsp;'logsegment',tempdb,master<BR>go<BR><BR><BR>select 
dbid, name,segmap<BR>from sysusages,&nbsp;&nbsp;sysdevices<BR>where 
sysdevices.low&nbsp;&nbsp;&lt;= sysusages.size +vstart<BR>and sysdevices.high 
&gt;=sysusages.size+vstart -1<BR>and dbid =2<BR>and (status=2 or status=3) <BR>
go<BR><BR>sp_cacheconfig tempdb_cache, '100M'<BR>go<BR>sp_poolconfig 
tempdb_cache,'50M','16K'<BR>go<BR>sp_bindcache 'tempdb_cache',tempdb<BR>go<BR>
sp_helpcache tempdb_cache<BR><BR>select name,id from syscharsets <BR><BR>dbcc 
traceon(3604)<BR>dbcc memusage<BR><BR><BR><BR>1&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; 
&nbsp; 数据库安装的优化<BR>1.1&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 应用数据库使用裸设备<BR>
若在UNIX（UNIXWARE）操作系统下安装数据库服务器，请将SYBASE应用数据库的设备(device)安装成裸设备。即在创建应用数据库设备（如：IVSP，DB160，NAP2000等）时用裸设备，把文件名指向 
/dev/dsk/ 子目录下的相应文件。系统数据库设备（如:master等）仍然指向文件系统。<BR>1.2&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp; &nbsp; 补丁程序<BR>
完成SYBASE数据库的安装，请注意原版的SYBASE软件都会带有最新的补丁，一定要把补丁打上，否则会出现一些莫名其妙的问题。FOR NT 
版的补丁是一个ZIP文件，解压至C:\SYBASE子目录即可。<BR>1.3&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 安装 
SYBASE 在线帮助<BR>在安装好 SYBASE 
后，在安装目录下有一文件：../scripts/ins_syn_sql，在服务器上执行该脚本：<BR>Sybase for Unix版：&nbsp; 
&nbsp;&nbsp;&nbsp;./isql -Usa -P -i../scripts/ins_syn_sql<BR>Sybase for 
Winnt版：&nbsp; &nbsp; isql -Usa -P -i\sybase\scripts\ins_syn_sql<BR>执行完毕后，即可在任意的 
SYBASE 客户端上连接上 SQL SERVER ，在线取得任意命令的帮助：<BR>&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;sp_syntax "关键字"<BR>如：&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;sp_syntax "alter"&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;即可列出所有包含"alter"字符的命令<BR>2&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; 
&nbsp; 数据库配置的优化<BR>2.1&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 优化master数据库<BR>
首先加大master设备空间，初始默认为30M，加大为150M。然后加大master数据库空间，默认数据段和日志段各为5M大小，建议改为数据段100M，日志段50M。<BR>alter 
database master on master=95<BR>2.2&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 
优化tempdb数据库<BR>
首先创建tempdb设备，分配给tempdb数据库，默认tempdb数据库数据段和日志段各为2M大小，并创建在master设备上，建议改为数据段200M，日志段50M，创建在tempdb设备上。<BR>alter 
database tempdb on tempdb=200<BR><BR>SQL 
SEVRER所有用户都共享工作表和临时表的tempdb数据库，tempdb主要瓶颈是磁盘I/0。解决办法是把tempdb放在更快的设备上。在UNIX环境中，把tempdb放在文件系统中而不用原始的设备。由于tempdb在创建数据时，自动在master设备上创建为2M的数据库，为了减少冲突，最好的办法是把tempdb从master设备中移走。为了达到上述目的，可采用如下办法实现：<BR><BR>1：在单用户状态下启动SQL 
SERVER<BR>启动单用户方法：dataserver -dmaster.dat -m<BR>
2：以sa登录<BR>3：在文件系统中创建一个哑数据库。<BR>4：删除sysusages和 
sysdatabase表中对现有tempdb数据库的引用<BR>5：获取哑数据库的数据库ID，相应修改sysusages和 
ysdatabase表对tempdb的引用<BR>6：重新启动数据库<BR>
以在newdevice中创建200M的tempdb数据库为例，执行过程如下：<BR>create database newtemp on 
newdevice=200<BR>go /* 创建新的数据库 */<BR>begin tran<BR>go /* 开始事务，防止操作错误时破坏整个SQL 
SERVER的运行*/<BR>delete sysusages where dbid = 2<BR>delete sysdatabases where dbid 
= 2<BR>go /*删除系统表对tempdb的引用，只能在单用户状态下执行*/<BR>select dbid from sysdatabases where 
name = ‘newtemp’<BR><BR>go /*获取newtemp数据库ID，假定为10*/<BR><BR>update sysusages set 
dbid = 2 where dbid=10<BR><BR>update sysdatabases set name=’tempdb’,dbid=2 where 
name=’newtemp’<BR><BR>go /*修改数据库的引用，对newtemp的引用改为对tempdb的引用*/<BR><BR>select 
name,dbid, from sysdatabases where name = ‘tempdb’<BR><BR>select * from 
sysusages where dbid = 2<BR><BR>go 
/*测试修改是否正确，正确则提交，否则可用rollback回退*/<BR><BR>commit tran<BR><BR>go 
/*修改成功，重新启动系统*/<BR><BR>这种方法只对tempdb有效，其他数据库不能采用这种方法。因为在SQL 
SERVER启动时，tempdb每次都重新初始化。<BR>2.3&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 
优化系统参数<BR>以下参数为标准建议值，可根据实际情况修改。<BR>优化系统参数的SQL脚本&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;注释<BR>sp_configure 'total memory', 100000&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;优化数据库的内存，应根据不同机器配置设置, 
建议为一半的物理内存大小。以db_block为单位，即每个单位为2k，上例为200M，默认为24M.<BR>sp_configure "lock scheme" 
, 1,"datarows"&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;系统默认为表级锁，优化为行锁<BR>sp_configure "number of locks" , 10000&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;加大最大锁进程数, 默认为5000。<BR>
（如果设置一个已经存在的表(tabel)的锁方式为行锁，则执行：<BR>alter table table_name lock 
datarows）<BR>sp_configure 'procedure cache percent' ,30&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;缺省值：20 建议值：procedure使用频率高时采用较大的值，不超过30<BR>sp_configure "number 
of user connections",100&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;最大用户连接数，默认为25，每个连接要占70k内存<BR>sp_configure 'number of 
devices',20&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;将最大设备文件数据改为15个<BR>sp_configure 
‘number of Open databases’,20&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;最大打开数据库个数，对于需在一台数据库服务上打个多个数据库则需加大此参数，默认为15<BR>Sp_configure 
‘max online engines CPU’,2&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;缺省值：1 
建议值：采用实际机器的CPU个数<BR>Sp_configure ‘total data cache size’,60000&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;缺省值：0 建议值：使用SQL 
SERVER内存的30%<BR>如果上述参数改动后SYBASE启动不正常，则可检查SYBASE的错误日志，把SYBASE.cfg中的相应选项修改为较小的值。<BR>
附：SYBASE SQL SERVER 内存的分配<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;1. SQL 
SERVER 可执行代码&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;3-4M<BR>&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp; &nbsp;2. SQL SERVER 使用的静态内存&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;2.2-3.25M<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;3. 
用户可配置的参数所占用内存，以下示例(11.9.2版)：<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;默认值&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 占用内存<BR>&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;用户连接数(user connections)&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;25&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp; &nbsp; 每个 约70k<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; 
&nbsp;打开的数据库数(open database)&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;12&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 每个 约60k<BR>&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;打开的对象数(open objects)&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 500&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 每个 约1k<BR>&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;打开的索引数(open indexs)&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 500&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 每个 约1k<BR>&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;锁数目(locks)&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 
5000&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;每个 约0.1k<BR>&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;数据库设备数(data device)&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 10&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 每个 约0.5k<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; 
&nbsp;4. 剩余部份分配给<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;过程缓存 ( 由 
procedure cache percent 决定，默认值为 20% )<BR>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp; &nbsp;数据缓存 ( 默认值为减去1、2、3项的 80% )<BR>2.4&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp; &nbsp; 优化数据库系统属性<BR>在sybase 
center中选择数据库属性，将属性中options选项中的下列项目选中。<BR>allow select into/bulk copy<BR>truncate 
log on checkpoint<BR>checkpoint on recovery<BR>abort transction on full log<BR>
free space accounting<BR>allow nulls by default<BR>auto identity column in 
non-unquie index <BR>方法二：在SQLPLUS中执行下列SQL脚本<BR>如：<BR>sp_dboption mydb,"abort 
tran on log full",true（设定当数据库的日志空间满时，就终止该进程，使用 sa 用户）<BR>sp_dboption mydb," 
select into/bulkcopy ",true<BR>sp_dboption mydb," trunc log on chkpt ",true<BR>
sp_dboption mydb," no chkpt on recovery",true<BR>sp_dboption mydb," no free 
space acctg ",true<BR>sp_dboption mydb,"allow nulls by default",true<BR>
sp_dboption mydb," auto identity dbo use only ",true<BR>2.5&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp; &nbsp; 创建阈值存储过程<BR>
可根据不同的应用修改以下脚本或创建多个阈值存储过程，并在配置阈值时指定相应的存储过程。<BR>&nbsp; &nbsp;create procedure 
sp_thresholdaction <BR>&nbsp; &nbsp;@dbname varchar(30),@segmentname 
varchar(30), @free_space int,@status int&nbsp;&nbsp;<BR>&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp;as dump transaction @dbname with no_log <BR>
print "LOG DUMP: '%1!' for '%2!' dumped",@segmentname,@dbname<BR>go<BR>2.6&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 配置多个阈值<BR>方法一： <BR>&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;打开 Sybase Central，双击相应数据库(database)的段 Segments -&gt;; 
logsegment，在&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;Thresholds 页面中可设置自动清除日志的阀值。其中有 
Last Chance 
的一行是系统默认的最后机会阀值，即系统日志空闲空间小于该值时为最后一次自动清除日志的机会。设置时阀值的大小可设为日志总空间大小的20%左右。<BR>
另外再增加多个阈值。<BR>方法二：<BR>1、使用如下指令查出数据库中日志的容量（用页表示）<BR>select sum(size) from 
master..sysusages where dbid=db_id("database_name" and (segmap&amp;4)=4<BR>
2、使用sp_addthreshold增加新的阈值，大小为日志容量的50%,如上面语句显示值为2048<BR>sp_addthreshold 
database_name,logsegment,1024，proc_dump_display<BR>注意：因一个大事务时可能会越过当前的threshold，所以必须加多个threshold，<BR>
使用命令select 
@@thresh_hysteresis查看数据库的滞后值，如结果为64页，则下一个阈值设为"最近的阈值-（2*64）"，请在所设阈值再按这种原则各增加两个更小的阈值。<BR>3&nbsp; 
&nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 索引的优化<BR>
在良好的数据库设计基础上，需高效地使用索引，并经常的维护索引，下文介绍关于索引的相关内容。<BR>3.1&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp; &nbsp; 创建索引<BR>索引分为三类：聚簇索引(clustered indexes)、非聚簇索引(nonclustered 
indexes)、覆盖索引(covering 
indexes)<BR>鉴于索引加快了查询速度，但减慢了数据更新速度的特点。可通过在一个段上建表，而在另一个段上建其非聚簇索引，而这两段分别在单独的物理设备上来改善操作性能。<BR>create 
[unique][clustered|nonclustered] index index_name on 
table_name(column_name...)<BR>3.2&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 
重建索引<BR>
　　随着数据行的插入、删除和数据页的分裂，有些索引页可能只包含几页数据，另外应用在执行大块I/O的时候，重建非聚簇索引可以降低分片，维护大块I/O的效率。重建索引实际上是重新组织B-树空间。在下面情况下需要重建索引：<BR>
　　(1)、数据和使用模式大幅度变化。<BR>　　(2)、排序的顺序发生改变。<BR>　　(3)、要进行大量插入操作或已经完成。<BR>
　　(4)、使用大块I/O的查询的磁盘读次数比预料的要多。<BR>　　(5)、由于大量数据修改，使得数据页和索引页没有充分使用而导致空间的使用超出估算。<BR>
　　(6)、dbcc检查出索引有问题。<BR>　　当重建聚簇索引时,这张表的所有非聚簇索引将被重建.<BR>3.3&nbsp; &nbsp;&nbsp; 
&nbsp;&nbsp; &nbsp; 索引统计信息的更新<BR>　　当在一个包含数据的表上创建索引的时候，SQL 
Server会创建分布数据页来存放有关索引的两种统计信息：分布表和密度表。优化器利用这个页来判断该索引对某个特定查询是否有用。但这个统计信息并不动态地重新计算。这意味着，当表的数据改变之后，统计信息有可能是过时的，从而影响优化器追求最有工作的目标。因此，在下面情况下应该运行update 
statistics命令：<BR>　　(1)、数据行的插入和删除修改了数据的分布。<BR>　　(2)、对用truncate 
table删除数据的表上增加数据行。<BR>　　(3)、修改索引列的值。<BR>4&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 
查询优化<BR>4.1&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; NOT IN子句<BR>不知大家是否喜欢使用‘NOT 
IN’这样的操作，如果是，那尽量使用(NOT) EXISTS 替代。<BR>例子：<BR>语句1<BR>SELECT dname, deptno FROM 
dept&nbsp;&nbsp;WHERE deptno NOT IN (SELECT deptno FROM emp);<BR>语句2<BR>SELECT 
dname, deptno FROM dept WHERE NOT EXISTS (SELECT deptno FROM emp WHERE 
dept.deptno = emp.deptno);<BR>明显的，2要比1的执行性能好很多，因为1中对emp进行了full table 
scan,这是很浪费时间的操作。而且1中没有用到emp的index，因为没有where子句。而2中的语句对emp进行的是range 
scan。<BR>4.2&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; 海量查询<BR>在海量查询时尽量少用格式转换。<BR>
如用<BR>WHERE a.order_no = b.order_no<BR>而不用<BR>WHERE TO_NUMBER 
(substr(a.order_no, instr(b.order_no, '.') - 1)= TO_NUMBER (substr(a.order_no, 
instr(b.order_no, '.') - 1)<BR>3）查询海量数据是可以使用optimizer hints，例如/*+ORDERED */ 
<BR>如<BR>SELECT /*+ FULL(EMP) */ E.ENAME FROM EMP E WHERE E.JOB = 
'CLERK';<BR>而不是<BR>SELECT E.ENAME FROM EMP E WHERE E.JOB || '' = 
'CLERK';<BR><BR><BR><BR>对于数据量较大和业务功能较复杂的系统，Sybase的默认参数根本无法满足需要，必须进行优化。系统数据库方面的优化从两方面进行，一个是调整数据库系统的一些性能参数的值，另一个是应用程序的调优。应用程序的调优调整hsql和sql的写法，配合sql合理的建索引，这里主要对Sybase系统一些基本的性能参数的调优进行一个小结。 
<P>1、内存<BR>&nbsp;&nbsp; 
内存是对性能影响最大，也是最需要也是最难调优的地方。内存调优一定要，常用的需要调整的参数有：<BR><BR>sp_configure “max 
memory”,0,”2600M” (设置为共享内存的75%,重启生效)<BR>sp_configure “allocate max shared mem”,1 
(启动的时候自动分配max memory指定的最大内存)<BR>sp_cacheconfig “default data 
cache”,”1300m”(设置数据缓存为max memory的一半)<BR>sp_cacheconfig “default data 
cache”,”cache_partition=2″<BR>sp_configure “procedure cache size”,102400 
(过程高速缓存,通常是max mem20%-30%,这里是200M,在大量的执行sql的时候这个参数一定要调大)<BR>sp_cacheconfig 
‘tempdb_cache’,'100m’,'mixed’ 
(创建一个100M命名高速缓存tempdb_cache给temdpb使用)<BR>sp_bindcache ‘tempdb_cache’,tempdb 
(将tempdb_cache绑定到tempdb)</P>
<P>&nbsp;&nbsp; 实际中遇到一个很头痛的问题， 32位Windows版本的Sybase 最大内存只能到搞到3G左右，"default data 
cache"的值超过 1500M 
Sybase实例就起不来了，导致服务器的16G内存形同虚设，所以如果大家的项目和我这个类似，服务器和操作系统由客户提供，还换不了的，内存不妨要求个4G就够了，多了也浪费。</P>
<P>2、CPU<BR>&nbsp;&nbsp; 
当服务器的CPU个数多于一个时，可以考虑多CPU。实际上对于OS会自动调度，设一下只不过是控制的更精确一点。实际需要根据CPU数来修改，若CPU=N，一般设置为N-1。设置这个参数，比如我的服务器8个CPU, 
就像下面这样设置：</P>
<P>sp_configure “max online engines”,7<BR>sp_configure “number of engines at 
startup”,7<BR>sp_configure “max parallel degree”,1 (并行的度，大于或等于1)<BR>sp_configure 
“number of worker processes”,7 (并行度＊并发连接数＊1.5倍)</P>
<P>3、连接数(这个没什么说的，数量管够就可以，默认数为25，可根据应用需要来修改。)<BR>sp_configure “number of user 
connections”,600</P>
<P>查询数据库死进程<BR>select * from master..syslogshold</P>
<P>4、锁<BR>&nbsp;&nbsp; 
数据库的锁机制其实是一个比较复杂的话题，这里只能简单说一下。Sybase数据库系统两个级别的锁机制：所有页锁、数据页锁。所有页锁在当数据库加锁时，既锁数据页，也锁索引页；数据页锁当数据库加锁时，只锁数据页，不锁索引页。<BR>&nbsp;&nbsp; 
Sybase支持三种类型的锁: 数据表锁、数据页锁、数据行锁。 一些常用的调优命令和策略如下:</P>
<P>sp_configure "number of locks",50000 （设置锁的数量）<BR>&nbsp;&nbsp;&nbsp; 
系统设置时要把锁的数量设大一点，简单说就是要管够；如果需要节省空间，减少维护量，使用所有页锁机制；而如果需要加快速度，空间足够，使用数据页锁机制。</P>
<P>&nbsp;&nbsp; sp_sysmon “00:10:00”,locks （检测表的使用情况）<BR>&nbsp;&nbsp; 
当通过监测发现锁竞争超过15%时，首先修改加锁最重的表的锁机制，然后再把数据页锁设置为数据行锁。如果发现螺旋锁多，则为该表建立单独的命名缓存并对命名缓存进行分区。</P>
<P>5、I/O<BR>&nbsp;&nbsp; 数据库调优总的思路是尽量减少和分散物理I/O，尽量减少网络I/O。</P>
<P>&nbsp;&nbsp; 减少物理I/O的办法有： 
在命名缓存中增加大块的I/O缓冲池，把数据分散到多个硬盘上,采用RAID技术,建立段，使一个表跨越多个硬盘等等，基本和其他的数据库软件调优一样。<BR>&nbsp;&nbsp; 
减少网络I/O的办法是采用大数据包。<BR>sp_configure "default network packet size",2048 
设置网络传送包的大小(需要重启动)<BR>sp_configure "max network packet size",2048</P>
<P>6、设备调整<BR>&nbsp;&nbsp; 主要调整两块： 
一个是业务数据库的数据设备与日志设备必须分开，添加临时数据库设备；另一个是调整Tempdb，这一条很重要却很容易被大家忽视。<BR>&nbsp;&nbsp; 
Tempdb是sybase数据库当中的临时库，用于存放中间结果和临时表。由于使用很频繁而默认大小又很小，我们需要加大其设备空间和库的大小，尽可能把tempdb放置到最快的硬盘上，并建立单独的命名缓存。<BR>sp_cacheconfig 
‘tempdb_cache’,'200m’,'mixed’ 
(创建一个200M命名高速缓存tempdb_cache给temdpb使用)<BR>sp_bindcache ‘tempdb_cache’,tempdb 
(将tempdb_cache绑定到tempdb)</P></DIV></DIV>
<DIV class="postfoot">		posted on 2008-07-09 17:32 <A href="http://www.blogjava.net/shanben/">存鹰之心于高远,取鹰之志而凌云,习鹰之性以涉险,融鹰之神在山巅.</A> 
阅读(6639) <A href="http://www.blogjava.net/shanben/archive/2008/07/09/213731.html#Post">评论(0)</A> 
&nbsp;<A href="http://www.blogjava.net/shanben/admin/EditPosts.aspx?postid=213731">编辑</A> 
&nbsp;<A 
href="http://www.blogjava.net/shanben/AddToFavorite.aspx?id=213731">收藏</A>  
所属分类: <A href="http://www.blogjava.net/shanben/category/32687.html">Sybase</A> 
	</DIV></DIV><IMG width="1" height="1" src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/213731.jpg"> <!--
<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
xmlns:dc="http://purl.org/dc/elements/1.1/"
xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/">
<rdf:Description
rdf:about="http://www.blogjava.net/shanben/archive/2008/07/09/213731.html"
dc:identifier="http://www.blogjava.net/shanben/archive/2008/07/09/213731.html"
dc:title="Sybase配置参数"
trackback:ping="http://www.blogjava.net/shanben/services/trackbacks/213731.aspx" />
</rdf:RDF>
--> 
<SCRIPT type="text/javascript">
//<![CDATA[
Sys.WebForms.PageRequestManager._initialize('AjaxHolder$scriptmanager1', document.getElementById('Form1'));
Sys.WebForms.PageRequestManager.getInstance()._updateControls(['tAjaxHolder$UpdatePanel1'], [], [], 90);
//]]>
</SCRIPT>
 
<DIV id="AjaxHolder_UpdatePanel1">
<STYLE>
td { font-size: 12px }
.commentTextBox 
{ 
    font-family : Verdana; 
    font-size: 13px;
 }
</STYLE>
 <!--Beging Temp Save--> 
<STYLE>.userData { BEHAVIOR: url(#default#userdata) }
	</STYLE>
 
<DIV class="userData" id="CommentsPersistDiv"></DIV>
<SCRIPT type="text/javascript">
function pageLoad()
{
    Sys.WebForms.PageRequestManager.getInstance().add_initializeRequest(handleInitializeRequest);
    //Sys.WebForms.PageRequestManager.getInstance().add_endRequest(handleEndRequest);
}

function handleInitializeRequest(sender, args)
{
    var prm = Sys.WebForms.PageRequestManager.getInstance();
    var eid = args.get_postBackElement().id;
    if (eid.indexOf("DeleteLink")>0) 
    {
       args.get_postBackElement().innerHTML = "<font color='red'>正在删除...</font>";         
    }    
    else if (eid.indexOf("btnSubmit")>0) 
    {
       document.getElementById("AjaxHolder_PostComment_ltSubmitMsg").innerHTML="正在提交...";
       document.getElementById("AjaxHolder_PostComment_btnSubmit").disabled = true;       
    }   
    else if(eid.indexOf("refreshList")>0)
    {
        document.getElementById("AjaxHolder_PostComment_refreshList").innerHTML="<font color='red'>正在刷新...</font>";
    }
   
}	

function TempSave(ElementID)
{
	try
	{
	CommentsPersistDiv.setAttribute("CommentContent",document.getElementById(ElementID).value);
	CommentsPersistDiv.save("CommentXMLStore");
	}
	catch(ex)
	{
	}
	
}
function Restore(ElementID)
{
	CommentsPersistDiv.load("CommentXMLStore");
	document.getElementById(ElementID).value=CommentsPersistDiv.getAttribute("CommentContent");
}	
			
			
</SCRIPT>
 <!--Ene TempSave--> 
<DIV id="divRefreshComments" style="text-align: right; font-size: 12px; margin-right: 10px; margin-bottom: 5px;"><A 
href="http://www.blogjava.net/RequireRegister.aspx">新用户注册</A>&nbsp;&nbsp;<A id="AjaxHolder_PostComment_refreshList" 
href="javascript:__doPostBack('AjaxHolder$PostComment$refreshList','')">刷新评论列表</A>&nbsp;&nbsp;</DIV>
<DIV class="commentform"><SPAN id="AjaxHolder_PostComment_ltSubmitMsg" style="color: red;"></SPAN> 
<BR><A name="Feedback"></A>	 
<DIV id="AjaxHolder_PostComment_divCommnentArea"></DIV>
<TABLE border="0" cellspacing="1" cellpadding="1">
  <TBODY>
  <TR>
    <TD id="AjaxHolder_PostComment_tdOnCommentForm" style="line-height: 1.5;" 
    colspan="3"></TD></TR>
  <TR>
    <TD colspan="3"></TD></TR>
  <TR>
    <TD width="75"></TD>
    <TD></TD>
    <TD></TD></TR>
  <TR>
    <TD></TD>
    <TD colspan="2"><A href="http://job.cnblogs.com/" 
      target="_blank">找优秀程序员，就在博客园</A>			 <!--<a href="http://www.cnblogs.com" target="_blank">博客园</a>&nbsp;  <a href="http://q.cnblogs.com/" target="_blank">博问</a>&nbsp; <a href="http://news.cnblogs.com" target="_blank">IT新闻</a>&nbsp; <a href="http://job.cnblogs.com/cate-java_programmer/" target="_blank">Java程序员招聘</a>-->
      			 </TD></TR>
  <TR>
    <TD width="55">标题</TD>
    <TD><INPUT name="AjaxHolder$PostComment$tbTitle" class="commenttb" id="AjaxHolder_PostComment_tbTitle" style="width: 320px;" type="text" value="re: Sybase配置参数"></TD>
    <TD><SPAN id="AjaxHolder_PostComment_RequiredFieldValidator1" style="color: red; visibility: hidden;">请输入标题</SPAN></TD></TR>
  <TR>
    <TD>姓名</TD>
    <TD><INPUT name="AjaxHolder$PostComment$tbName" class="commenttb" id="AjaxHolder_PostComment_tbName" style="width: 320px;" type="text"></TD>
    <TD><SPAN id="AjaxHolder_PostComment_RequiredFieldValidator2" style="color: red; visibility: hidden;">请输入你的姓名</SPAN></TD></TR>
  <TR>
    <TD>主页</TD>
    <TD><INPUT name="AjaxHolder$PostComment$tbUrl" class="commenttb" id="AjaxHolder_PostComment_tbUrl" style="width: 320px;" type="text"></TD>
    <TD><FONT face="宋体"></FONT></TD></TR>
  <TR>
    <TD align="left" colspan="3">
      <TABLE class="CommentForm" id="AjaxHolder_PostComment_tbCaptchaImage" 
      border="0" cellspacing="0" cellpadding="0">
        <TBODY>
        <TR>
          <TD colspan="3"><SPAN id="AjaxHolder_PostComment_Requiredfieldvalidator4" 
            style="color: red; display: none;">请输入验证码</SPAN>							 <SPAN id="AjaxHolder_PostComment_lblImage" 
            style="color: red; font-weight: bold;"></SPAN>						 </TD></TR>
        <TR>
          <TD width="78">验证码</TD>
          <TD><INPUT name="AjaxHolder$PostComment$CodeNumberTextBox" id="AjaxHolder_PostComment_CodeNumberTextBox" type="text">*&nbsp;&nbsp;<IMG 
            src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/JpegImage.jpg"></TD>
          <TD align="left"></TD></TR></TBODY></TABLE></TD></TR>
  <TR>
    <TD colspan="3">内容(请不要发表任何与政治相关的内容)				 <SPAN id="AjaxHolder_PostComment_RequiredFieldValidator3" 
      style="color: red; visibility: hidden;">请输入评论内容</SPAN><BR><TEXTAREA name="AjaxHolder$PostComment$tbComment" class="commentTextBox" id="AjaxHolder_PostComment_tbComment" style="width: 480px; height: 220px;" onkeydown="ctlent(event,'AjaxHolder_PostComment_tbComment')" rows="10" cols="50"></TEXTAREA></TD></TR>
  <TR>
    <TD colspan="3"><SPAN id="AjaxHolder_PostComment_Message" style="color: red;"></SPAN>
      		 </TD>
  <TR>
    <TD colspan="3"><INPUT name="AjaxHolder$PostComment$chkRemember" tabindex="-1" 
      id="AjaxHolder_PostComment_chkRemember" type="checkbox" 
      checked="checked"><LABEL for="AjaxHolder_PostComment_chkRemember">Remember 
      Me?</LABEL></TD></TR>
  <TR>
    <TD height="23"><INPUT name="AjaxHolder$PostComment$btnSubmit" class="commentButton" id="AjaxHolder_PostComment_btnSubmit" onclick="TempSave('AjaxHolder_PostComment_tbComment');WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions(&quot;AjaxHolder$PostComment$btnSubmit&quot;, &quot;&quot;, true, &quot;&quot;, &quot;&quot;, false, false))" type="submit" value="提交">
      				 </TD>
    <TD height="23" colspan="2">&nbsp;				<A id="AjaxHolder_PostComment_lnkLogin" 
      href="http://www.blogjava.net/login.aspx?ReturnURL=http://www.blogjava.net/shanben/archive/2008/07/09/213731.html&amp;SourceURL=/shanben/archive/2008/07/09/213731.html">登录</A>&nbsp;&nbsp;<!--<a id="AjaxHolder_PostComment_linkLoginComment" OnClick="if(document.getElementById('AjaxHolder_PostComment_tbComment').value != '') return confirm('未提交的评论内容将会丢失, 你真的要进入高级评论吗?');" href="http://www.blogjava.net/shanben/archive/2008/07/09/213731.html?login=1#Post">使用高级评论</a>&nbsp;&nbsp;<a href="http://www.blogjava.net/RequireRegister.aspx">新用户注册</a>&nbsp;&nbsp;<A href="#Top">返回页首</A>&nbsp;&nbsp;<a id="AjaxHolder_PostComment_lbRestore" OnClick="Restore('AjaxHolder_PostComment_tbComment'); return false;" href="/shanben/archive/2008/07/09/213731.html#Post">恢复上次提交</a>&nbsp;&nbsp;-->&nbsp;&nbsp;&nbsp;&nbsp;
      				</TD></TR>
  <TR>
    <TD colspan="3"><LABEL 
  class="CtrlEnter">[使用Ctrl+Enter键可以直接提交]</LABEL></TD></TR>
  <TR>
    <TD colspan="3"><!--该文被作者在 2008-07-12 21:14 编辑过--></TD></TR><!--
		<TR>
			<TD colSpan="3" height="5"></TD>
		</TR>	
		-->	
  		
  <TR>
    <TD colspan="3">
<SCRIPT type="text/javascript">
var googletag = googletag || {};
googletag.cmd = googletag.cmd || [];
(function() {
var gads = document.createElement('script');
gads.async = true;
gads.type = 'text/javascript';
var useSSL = 'https:' == document.location.protocol;
gads.src = (useSSL ? 'https:' : 'http:') + 
'//www.googletagservices.com/tag/js/gpt.js';
var node = document.getElementsByTagName('script')[0];
node.parentNode.insertBefore(gads, node);
})();
</SCRIPT>
       
<SCRIPT type="text/javascript">
googletag.cmd.push(function() {
googletag.defineSlot('/1090369/blogjava_blogpost_bottom', [300, 250], 'div-gpt-ad-1364133350381-0').addService(googletag.pubads());
googletag.pubads().enableSingleRequest();
googletag.enableServices();
});
</SCRIPT>
       <!-- blogjava_blogpost_bottom --> 
      <DIV id="div-gpt-ad-1364133350381-0" style="width: 300px; height: 250px;">
<SCRIPT type="text/javascript">
googletag.cmd.push(function() { googletag.display('div-gpt-ad-1364133350381-0'); });
</SCRIPT>
       </DIV><BR></TD></TR>
  <TR>
    <TD colspan="3"></TD></TR>
  <TR>
    <TD colspan="3"></TD></TR>
  <TR>
    <TD height="1" colspan="3">网站导航:
      <DIV id="blogsite"><A title="开发者的网上家园" 
      href="http://www.cnblogs.com/">博客园</A>&nbsp;&nbsp;			<A href="http://news.cnblogs.com/">IT新闻</A>&nbsp;&nbsp;
      			<A href="http://kb.cnblogs.com/">知识库</A>&nbsp;&nbsp;			<A href="http://www.cppblog.com/">C++博客</A>&nbsp;&nbsp;
      			<A href="http://job.cnblogs.com/">程序员招聘</A>&nbsp;&nbsp;			<A href="http://www.blogjava.net/shanben/archive/2008/07/09/213731.html?opt=admin">管理</A>
      			 </DIV></TD></TR>
  <TR>
    <TD height="5" colspan="3">
      <DIV id="divRelativePosts">相关文章:				 
      <UL style="padding-left: 0px; margin-top: 0px;">
        <LI style="list-style: none;"><A id="AjaxHolder_PostComment_ctl07_RelativePostsList_ctl01_Hyperlink1" 
        href="http://www.blogjava.net/shanben/archive/2008/09/04/226863.html">Sybase 
        ASE表分區的使用 </A>			 </LI>
        <LI style="list-style: none;"><A id="AjaxHolder_PostComment_ctl07_RelativePostsList_ctl02_Hyperlink1" 
        href="http://www.blogjava.net/shanben/archive/2008/09/02/226451.html">利用DM水平分区优化系统</A>
        			 </LI>
        <LI style="list-style: none;"><A id="AjaxHolder_PostComment_ctl07_RelativePostsList_ctl03_Hyperlink1" 
        href="http://www.blogjava.net/shanben/archive/2008/09/02/226399.html">sybase数据库存储过程编写经验以及方法</A>
        			 </LI>
        <LI style="list-style: none;"><A id="AjaxHolder_PostComment_ctl07_RelativePostsList_ctl04_Hyperlink1" 
        href="http://www.blogjava.net/shanben/archive/2008/09/02/226397.html">Sybase數據庫性能調優的一些小方面</A>
        			 </LI>
        <LI style="list-style: none;"><A id="AjaxHolder_PostComment_ctl07_RelativePostsList_ctl05_Hyperlink1" 
        href="http://www.blogjava.net/shanben/archive/2008/07/20/216156.html">sp_sysmon性能诊断结果分析</A>
        			 </LI>
        <LI style="list-style: none;"><A id="AjaxHolder_PostComment_ctl07_RelativePostsList_ctl06_Hyperlink1" 
        href="http://www.blogjava.net/shanben/archive/2008/07/19/216016.html">sybase常用的命令集合</A>
        			 </LI>
        <LI style="list-style: none;"><A id="AjaxHolder_PostComment_ctl07_RelativePostsList_ctl07_Hyperlink1" 
        href="http://www.blogjava.net/shanben/archive/2008/07/16/215161.html">查寻提示改变优化器 
        </A>			 </LI>
        <LI style="list-style: none; display: none;"><A id="AjaxHolder_PostComment_ctl07_RelativePostsList_ctl08_Hyperlink1" 
        href="http://www.blogjava.net/shanben/archive/2008/07/09/213731.html">Sybase配置参数</A>
        			 </LI>
        <LI style="list-style: none;"><A id="AjaxHolder_PostComment_ctl07_RelativePostsList_ctl09_Hyperlink1" 
        href="http://www.blogjava.net/shanben/archive/2008/07/08/213244.html">Sybase 
        常用sql语句</A>			 </LI>
        <LI style="list-style: none;"><A id="AjaxHolder_PostComment_ctl07_RelativePostsList_ctl10_Hyperlink1" 
        href="http://www.blogjava.net/shanben/archive/2008/07/07/213040.html">数据类型的不匹配可能会导致索引失效</A>
        			 </LI></UL></DIV></TD></TR>
  <TR>
    <TD colspan="3">&nbsp;</TD></TR>
  <TR>
    <TD height="5" colspan="3"></TD></TR>
  <TR>
    <TD colspan="3"></TD></TR></TBODY></TABLE></DIV>
<DIV id="AjaxHolder_PostComment_ValidationSummary1" style="color: red; display: none;"></DIV></DIV></DIV>
<P id="footer">	Powered by: 	 <BR><A name="Hyperlink1" id="Footer1_Hyperlink3" 
style="font-family: Verdana; font-size: 12px;" 
href="http://www.blogjava.net/">BlogJava</A>	 <BR>	Copyright © 
存鹰之心于高远,取鹰之志而凌云,习鹰之性以涉险,融鹰之神在山巅. </P>
<SCRIPT type="text/javascript">
//<![CDATA[
var Page_ValidationSummaries =  new Array(document.getElementById("AjaxHolder_PostComment_ValidationSummary1"));
var Page_Validators =  new Array(document.getElementById("AjaxHolder_PostComment_RequiredFieldValidator1"), document.getElementById("AjaxHolder_PostComment_RequiredFieldValidator2"), document.getElementById("AjaxHolder_PostComment_Requiredfieldvalidator4"), document.getElementById("AjaxHolder_PostComment_RequiredFieldValidator3"));
//]]>
</SCRIPT>
 
<SCRIPT type="text/javascript">
//<![CDATA[
var AjaxHolder_PostComment_RequiredFieldValidator1 = document.all ? document.all["AjaxHolder_PostComment_RequiredFieldValidator1"] : document.getElementById("AjaxHolder_PostComment_RequiredFieldValidator1");
AjaxHolder_PostComment_RequiredFieldValidator1.controltovalidate = "AjaxHolder_PostComment_tbTitle";
AjaxHolder_PostComment_RequiredFieldValidator1.errormessage = "请输入标题";
AjaxHolder_PostComment_RequiredFieldValidator1.evaluationfunction = "RequiredFieldValidatorEvaluateIsValid";
AjaxHolder_PostComment_RequiredFieldValidator1.initialvalue = "";
var AjaxHolder_PostComment_RequiredFieldValidator2 = document.all ? document.all["AjaxHolder_PostComment_RequiredFieldValidator2"] : document.getElementById("AjaxHolder_PostComment_RequiredFieldValidator2");
AjaxHolder_PostComment_RequiredFieldValidator2.controltovalidate = "AjaxHolder_PostComment_tbName";
AjaxHolder_PostComment_RequiredFieldValidator2.errormessage = "请输入你的姓名";
AjaxHolder_PostComment_RequiredFieldValidator2.evaluationfunction = "RequiredFieldValidatorEvaluateIsValid";
AjaxHolder_PostComment_RequiredFieldValidator2.initialvalue = "";
var AjaxHolder_PostComment_Requiredfieldvalidator4 = document.all ? document.all["AjaxHolder_PostComment_Requiredfieldvalidator4"] : document.getElementById("AjaxHolder_PostComment_Requiredfieldvalidator4");
AjaxHolder_PostComment_Requiredfieldvalidator4.controltovalidate = "AjaxHolder_PostComment_CodeNumberTextBox";
AjaxHolder_PostComment_Requiredfieldvalidator4.errormessage = "请输入验证码";
AjaxHolder_PostComment_Requiredfieldvalidator4.display = "Dynamic";
AjaxHolder_PostComment_Requiredfieldvalidator4.evaluationfunction = "RequiredFieldValidatorEvaluateIsValid";
AjaxHolder_PostComment_Requiredfieldvalidator4.initialvalue = "";
var AjaxHolder_PostComment_RequiredFieldValidator3 = document.all ? document.all["AjaxHolder_PostComment_RequiredFieldValidator3"] : document.getElementById("AjaxHolder_PostComment_RequiredFieldValidator3");
AjaxHolder_PostComment_RequiredFieldValidator3.controltovalidate = "AjaxHolder_PostComment_tbComment";
AjaxHolder_PostComment_RequiredFieldValidator3.errormessage = "请输入评论内容";
AjaxHolder_PostComment_RequiredFieldValidator3.evaluationfunction = "RequiredFieldValidatorEvaluateIsValid";
AjaxHolder_PostComment_RequiredFieldValidator3.initialvalue = "";
var AjaxHolder_PostComment_ValidationSummary1 = document.all ? document.all["AjaxHolder_PostComment_ValidationSummary1"] : document.getElementById("AjaxHolder_PostComment_ValidationSummary1");
AjaxHolder_PostComment_ValidationSummary1.showmessagebox = "True";
AjaxHolder_PostComment_ValidationSummary1.showsummary = "False";
//]]>
</SCRIPT>
 
<SCRIPT type="text/javascript">
//<![CDATA[

var Page_ValidationActive = false;
if (typeof(ValidatorOnLoad) == "function") {
    ValidatorOnLoad();
}

function ValidatorOnSubmit() {
    if (Page_ValidationActive) {
        return ValidatorCommonOnSubmit();
    }
    else {
        return true;
    }
}
        
document.getElementById('AjaxHolder_PostComment_ValidationSummary1').dispose = function() {
    Array.remove(Page_ValidationSummaries, document.getElementById('AjaxHolder_PostComment_ValidationSummary1'));
}
Sys.Application.initialize();

document.getElementById('AjaxHolder_PostComment_RequiredFieldValidator1').dispose = function() {
    Array.remove(Page_Validators, document.getElementById('AjaxHolder_PostComment_RequiredFieldValidator1'));
}

document.getElementById('AjaxHolder_PostComment_RequiredFieldValidator2').dispose = function() {
    Array.remove(Page_Validators, document.getElementById('AjaxHolder_PostComment_RequiredFieldValidator2'));
}

document.getElementById('AjaxHolder_PostComment_Requiredfieldvalidator4').dispose = function() {
    Array.remove(Page_Validators, document.getElementById('AjaxHolder_PostComment_Requiredfieldvalidator4'));
}

document.getElementById('AjaxHolder_PostComment_RequiredFieldValidator3').dispose = function() {
    Array.remove(Page_Validators, document.getElementById('AjaxHolder_PostComment_RequiredFieldValidator3'));
}
//]]>
</SCRIPT>
 </FORM>
<SCRIPT src="Sybase配置参数%20-%20志当存高远,功到自然成!%20-%20BlogJava_files/ShowHidden.js" type="text/javascript"></SCRIPT>
	 
<SCRIPT type="text/javascript">
	  var _gaq = _gaq || [];
	  _gaq.push(['_setAccount', 'UA-476124-3']);
	  _gaq.push(['_trackPageview']);

	  (function() {
		var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
		ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
		var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
	  })();
	</SCRIPT>
 </BODY></HTML>
